package cn.zt.mapper;

import cn.zt.domain.TLoanDetails;
import cn.zt.domain.vo.LoanVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 田桑
* @description 针对表【t_loan_details(贷款产品详细表)】的数据库操作Mapper
* @createDate 2024-09-05 18:40:52
* @Entity cn.zt.domain.TLoanDetails
*/
public interface TLoanDetailsMapper extends BaseMapper<TLoanDetails> {

    @Select("SELECT t_loan_product.id,t_loan_product.name,t_loan_product.yield,t_loan_product.state,t_loan_product_type.type_name,t_loan_product_type.document" +
            " FROM t_loan_product LEFT JOIN t_loan_product_type ON t_loan_product.id = t_loan_product_type.product_id")
    List<LoanVO> loanList();
}




